home *** CD-ROM | disk | FTP | other *** search
/ Power Programmierung / Power-Programmierung (Tewi)(1994).iso / magazine / dbms_mag / 9104 / sql3.apr < prev    next >
Text File  |  1991-03-01  |  252b  |  2 lines
  1.  
  2. CREATE VIEW MY_EMPLOYEES     AS SELECT * FROM EMPLOYEE        WHERE DEPARTMENT =               (SELECT DEPARTMENT FROM MANAGER_XREF                WHERE USER_NAME = USER)         WITH CHECK OPTIONGRANT ALL PRIVILEGES ON MY_EMPLOYEES TO PUBLIC